# -*- coding:utf-8 -*-
"""
Author：Administrator
Date:2023年03月17日
"""
import openpyxl

myBook=openpyxl.load_workbook('员工表.xlsx',data_only=True)
mySheet=myBook.active
for myRow in range(mySheet.max_row,1,-1):
	if '江北县' not in mySheet[myRow][2].value:
		mySheet.delete_rows(myRow)
myBook.save('结果表-员工表.xlsx')